RE: [SQL] Single vs. multiple indexes - Mailing list pgsql-sql

From Herouth Maoz
Subject RE: [SQL] Single vs. multiple indexes
Date
Msg-id l03110707b1ce484a3a60@[147.233.159.109]
Whole thread Raw
In response to RE: [SQL] Single vs. multiple indexes  ("Jackson, DeJuan" <djackson@cpsgroup.com>)
List pgsql-sql
At 20:37 +0300 on 10/7/98, Jackson, DeJuan wrote:


> >
> But let's not forget one of the wonders of PostgreSQL.  In this world
> you can have your cake and eat it to.  So, create all 4 indices and let
> the optimizer sort em out for your queries.

Yes, but whenever you update or insert a row, it's that much slower. One
should always remember not to go wild with indexing - they carry a penalty
on INSERT and UPDATE.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma



pgsql-sql by date:

Previous
From: Michael J Schout
Date:
Subject: Re: [SQL] The date of an entry?
Next
From: Sergio Brandano
Date:
Subject: [SQL] empty data